Kolumna EpisodeID tabeli Episode

Definicja kolumny EpisodeID tabeli Episode

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(20)

Mandatory

Yes

Comment

 


Kolumna PatientID tabeli Episode

Definicja kolumny PatientID tabeli Episode

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DischargeModeID tabeli Episode

Definicja kolumny DischargeModeID tabeli Episode

Name

DischargeModeID

Code

DischargeModeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AdmissionModeID tabeli Episode

Definicja kolumny AdmissionModeID tabeli Episode

Name

AdmissionModeID

Code

AdmissionModeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ReferralID tabeli Episode

Definicja kolumny ReferralID tabeli Episode

Name

ReferralID

Code

ReferralID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HealtProgrammeID tabeli Episode

Definicja kolumny HealtProgrammeID tabeli Episode

Name

HealtProgrammeID

Code

HealthProgrammeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractID tabeli Episode

Definicja kolumny ContractID tabeli Episode

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kontrakt z którego zakresu zostal zaimportowany zestaw


Kolumna MalignantTumourId tabeli Episode

Definicja kolumny MalignantTumourId tabeli Episode

Name

MalignantTumourId

Code

MalignantTumourId

Data Type

NUMBER(10)

Mandatory

No

Comment

ID nowotworu zlosliwego


Kolumna ExternalEpisodeID tabeli Episode

Definicja kolumny ExternalEpisodeID tabeli Episode

Name

ExternalEpisodeID

Code

ExternalEpisodeID

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna AdmissionDate tabeli Episode

Definicja kolumny AdmissionDate tabeli Episode

Name

AdmissionDate

Code

AdmissionDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna DischargeDate tabeli Episode

Definicja kolumny DischargeDate tabeli Episode

Name

DischargeDate

Code

DischargeDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna MainBook_childNo tabeli Episode

Definicja kolumny MainBook_childNo tabeli Episode

Name

MainBook_childNo

Code

MainBook_childNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MainBookNo tabeli Episode

Definicja kolumny MainBookNo tabeli Episode

Name

MainBookNo

Code

MainBookNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MainBookPos tabeli Episode

Definicja kolumny MainBookPos tabeli Episode

Name

MainBookPos

Code

MainBookPos

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MainBookYear tabeli Episode

Definicja kolumny MainBookYear tabeli Episode

Name

MainBookYear

Code

MainBookYear

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EpisodeType tabeli Episode

Definicja kolumny EpisodeType tabeli Episode

Name

EpisodeType

Code

EpisodeType

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna causeOfDeath tabeli Episode

Definicja kolumny causeOfDeath tabeli Episode

Name

causeOfDeath

Code

causeOfDeath

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna toSend tabeli Episode

Definicja kolumny toSend tabeli Episode

Name

toSend

Code

toSend

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Character tabeli Episode

Definicja kolumny Character tabeli Episode

Name

Character

Code

Character

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna HospitalizationMode tabeli Episode

Definicja kolumny HospitalizationMode tabeli Episode

Name

HospitalizationMode

Code

HospitalizationMode

Data Type

VARCHAR2(5)

Mandatory

No

Comment

 


Kolumna Date tabeli Episode

Definicja kolumny Date tabeli Episode

Name

Date

Code

Date

Data Type

DATE

Mandatory

No

Comment

 


Kolumna AccountVersion tabeli Episode

Definicja kolumny AccountVersion tabeli Episode

Name

AccountVersion

Code

AccountVersion

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ModDate tabeli Episode

Definicja kolumny ModDate tabeli Episode

Name

ModDate

Code

ModDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Version tabeli Episode

Definicja kolumny Version tabeli Episode

Name

Version

Code

Version

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna toDelete tabeli Episode

Definicja kolumny toDelete tabeli Episode

Name

toDelete

Code

toDelete

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna CurrentAccountDataStatusID tabeli Episode

Definicja kolumny CurrentAccountDataStatusID tabeli Episode

Name

CurrentAccountDataStatusID

Code

CurrentAccountDataStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MainBookFull tabeli Episode

Definicja kolumny MainBookFull tabeli Episode

Name

MainBookFull

Code

MainBookFull

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna isEmergency tabeli Episode

Definicja kolumny isEmergency tabeli Episode

Name

isEmergency

Code

isEmergency

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna NumberOfMonthSinceFallingIll tabeli Episode

Definicja kolumny NumberOfMonthSinceFallingIll tabeli Episode

Name

NumberOfMonthSinceFallingIll

Code

NumberOfMonthSinceFallingIll

Data Type

NUMBER(5)

Mandatory

No

Comment

Liczba miesiecy od zachorowania


Kolumna NumberOfDaysFromDischarge tabeli Episode

Definicja kolumny NumberOfDaysFromDischarge tabeli Episode

Name

NumberOfDaysFromDischarge

Code

NumberOfDaysFromDischarge

Data Type

NUMBER(5)

Mandatory

No

Comment

Liczba dnia od wypisu chorego do przyjecia na oodzial


Kolumna BarthelADL tabeli Episode

Definicja kolumny BarthelADL tabeli Episode

Name

BarthelADL

Code

BarthelADL

Data Type

NUMBER(5)

Mandatory

No

Comment

Ocena czynnosci dnia codziennego wg skali Barthela ADL


Kolumna ASIA tabeli Episode

Definicja kolumny ASIA tabeli Episode

Name

ASIA

Code

ASIA

Data Type

NUMBER(5)

Mandatory

No

Comment

Ocena funkcjonalna wg skali ASIA w motorycznej ocenie skali miesni


Kolumna GMFCS tabeli Episode

Definicja kolumny GMFCS tabeli Episode

Name

GMFCS

Code

GMFCS

Data Type

NUMBER(5)

Mandatory

No

Comment

Ocena glebokosci niepelnosprawnosci wg GMFCS


Kolumna MainDiagnosis tabeli Episode

Definicja kolumny MainDiagnosis tabeli Episode

Name

MainDiagnosis

Code

MainDiagnosis

Data Type

VARCHAR2(5)

Mandatory

No

Comment

Diagnoza glówna


Kolumna AdditionalDiagnosis1 tabeli Episode

Definicja kolumny AdditionalDiagnosis1 tabeli Episode

Name

AdditionalDiagnosis1

Code

AdditionalDiagnosis1

Data Type

VARCHAR2(5)

Mandatory

No

Comment

Diagnoza wspólistniejaca 1


Kolumna AdditionalDiagnosis2 tabeli Episode

Definicja kolumny AdditionalDiagnosis2 tabeli Episode

Name

AdditionalDiagnosis2

Code

AdditionalDiagnosis2

Data Type

VARCHAR2(5)

Mandatory

No

Comment

Diagnoza wspólistniejaca 2


Kolumna AdditionalDiagnosis3 tabeli Episode

Definicja kolumny AdditionalDiagnosis3 tabeli Episode

Name

AdditionalDiagnosis3

Code

AdditionalDiagnosis3

Data Type

VARCHAR2(5)

Mandatory

No

Comment

Diagnoza wspólistniejaca 3


Kolumna AdditionalDiagnosis4 tabeli Episode

Definicja kolumny AdditionalDiagnosis4 tabeli Episode

Name

AdditionalDiagnosis4

Code

AdditionalDiagnosis4

Data Type

VARCHAR2(5)

Mandatory

No

Comment

Diagnoza wspólistniejaca 4


Kolumna AdditionalDiagnosis5 tabeli Episode

Definicja kolumny AdditionalDiagnosis5 tabeli Episode

Name

AdditionalDiagnosis5

Code

AdditionalDiagnosis5

Data Type

VARCHAR2(5)

Mandatory

No

Comment

Diagnoza wspólistniejaca 5


Kolumna NfzVersionNo tabeli Episode

Definicja kolumny NfzVersionNo tabeli Episode

Name

NfzVersionNo

Code

NfzVersionNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NfzAccountVersionNo tabeli Episode

Definicja kolumny NfzAccountVersionNo tabeli Episode

Name

NfzAccountVersionNo

Code

NfzAccountVersionNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NfzLastSwzMessageNo tabeli Episode

Definicja kolumny NfzLastSwzMessageNo tabeli Episode

Name

NfzLastSwzMessageNo

Code

NfzLastSwzMessageNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RumCardNumber tabeli Episode

Definicja kolumny RumCardNumber tabeli Episode

Name

RumCardNumber

Code

RumCardNumber

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Numer karty pacjenta (tylko dla Slaskiego OW NFZ wykorzystywane przy autoryzacji pacjenta)


Kolumna RumDuplicateNo tabeli Episode

Definicja kolumny RumDuplicateNo tabeli Episode

Name

RumDuplicateNo

Code

RumDuplicateNo

Data Type

VARCHAR2(2)

Mandatory

No

Comment

Numer duplikatu karty (tylko dla Slaskiego OW NFZ wykorzystywane przy autoryzacji pacjenta)


Kolumna AuthorizationDate tabeli Episode

Definicja kolumny AuthorizationDate tabeli Episode

Name

AuthorizationDate

Code

AuthorizationDate

Data Type

DATE

Mandatory

No

Comment

Data i czas autoryzacji karta danego zestawu swiadczen (tylko dla Slaskiego OW NFZ)


Kolumna HashCode tabeli Episode

Definicja kolumny HashCode tabeli Episode

Name

HashCode

Code

HashCode

Data Type

VARCHAR2(40)

Mandatory

No

Comment

Md5 do monitorowania zmian w danych


Kolumna AdmissionBedsores tabeli Episode

Definicja kolumny AdmissionBedsores tabeli Episode

Name

AdmissionBedsores

Code

AdmissionBedsores

Data Type

NUMBER(5)

Mandatory

No

Comment

Czy odlezyny byly przed przyjeciem do szpitala


Kolumna DischargeBedsores tabeli Episode

Definicja kolumny DischargeBedsores tabeli Episode

Name

DischargeBedsores

Code

DischargeBedsores

Data Type

NUMBER(5)

Mandatory

No

Comment

Czy odlezyny byly po wypisie ze szpitala


Kolumna BrainDeath tabeli Episode

Definicja kolumny BrainDeath tabeli Episode

Name

BrainDeath

Code

BrainDeath

Data Type

NUMBER(5)

Mandatory

No

Comment

Czy stwierdzono ustanie czynnosci mózgu


Kolumna BrainDeathDecisionDT tabeli Episode

Definicja kolumny BrainDeathDecisionDT tabeli Episode

Name

BrainDeathDecisionDT

Code

BrainDeathDecisionDT

Data Type

DATE

Mandatory

No

Comment

Data i godzina wydania orzeczenia


Kolumna OrganDonation tabeli Episode

Definicja kolumny OrganDonation tabeli Episode

Name

OrganDonation

Code

OrganDonation

Data Type

NUMBER(5)

Mandatory

No

Comment

Czy jest dawca organów


Kolumna Cardiolvef tabeli Episode

Definicja kolumny Cardiolvef tabeli Episode

Name

Cardiolvef

Code

Cardiolvef

Data Type

NUMBER(10)

Mandatory

No

Comment

Ocena funkcji skurczowej lewej komory serca w przypadku kardiologi


Kolumna RehabilitationIcd9Code tabeli Episode

Definicja kolumny RehabilitationIcd9Code tabeli Episode

Name

RehabilitationIcd9Code

Code

RehabilitationIcd9Code

Data Type

VARCHAR2(8)

Mandatory

No

Comment

Kod ICD9 w rehabilitacji ogólnoustrojowej


Kolumna RehabilitationIcd10Code tabeli Episode

Definicja kolumny RehabilitationIcd10Code tabeli Episode

Name

RehabilitationIcd10Code

Code

RehabilitationIcd10Code

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Jod ICD10 w rehabilitacji ogólnoustrojowej


Kolumna Rankin tabeli Episode

Definicja kolumny Rankin tabeli Episode

Name

Rankin

Code

Rankin

Data Type

NUMBER(10)

Mandatory

No

Comment

Ocena stopnia niepelnosprawnosci wg skali Rankina w rehabilitacji ogolnoustrojowej


Kolumna NyhaScale tabeli Episode

Definicja kolumny NyhaScale tabeli Episode

Name

NyhaScale

Code

NyhaScale

Data Type

VARCHAR2(3)

Mandatory

No

Comment

Skala NYHA


Kolumna Weight tabeli Episode

Definicja kolumny Weight tabeli Episode

Name

Weight

Code

Weight

Data Type

NUMBER(7,4)

Mandatory

No

Comment

waga pacjenta w dniu przyjecia


Kolumna Height tabeli Episode

Definicja kolumny Height tabeli Episode

Name

Height

Code

Height

Data Type

NUMBER(7,4)

Mandatory

No

Comment

wzrost pacjenta w dniu przyjecia


Kolumna HasInfection tabeli Episode

Definicja kolumny HasInfection tabeli Episode

Name

HasInfection

Code

HasInfection

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy wystapilo zakazenie wewnatrzszpitalne


Kolumna InfectionICDID tabeli Episode

Definicja kolumny InfectionICDID tabeli Episode

Name

InfectionICDID

Code

InfectionICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

Rozpoznanie ICD10 zakazenia wewnatrzszpitalnego


Lista kluczy tabeli Episode

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Episode

Definicja klucza Identifier_1 tabeli Episode

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment